<?php
$DB_Host     = "localhost";					//数据库地址
$DB_Database     = "11111";					//数据库名称
$DB_User    = "root";					//数据库用户
$DB_Password     = "";					//数据库用户密码
include_once "config_db.php";
include_once "../inc/linb.php";
include_once "../inc/template.php";
function qwe($tables,$tablesname,$optionid,$title)
{ 
	global $db1;
	$db1->query("SELECT * FROM cn_customer_option_value WHERE optionID=".$optionid." and customerID  like '".$title."' " );
	 if($db1->next_record()) 
	 { 
     return $db1->Record[$tablesname];
      }
}
$strSql = "SELECT * FROM cn_customer LIMIT 2700 , 300 ";
$execc = "SELECT id FROM cn_customer LIMIT 2700 , 300 ";
$resultc = mysql_query( $execc );
				$intNum = mysql_num_rows( $resultc );
				$db->query( $strSql );
while ( $db->next_record( ) )
				{
echo "INSERT INTO `cms2`.`tun2_member` (`id` ,`user` ,`password` ,`email` ,`points` ,`name` ,`sex` ,`place` )VALUES (NULL , '";
echo $db->Record['name'];
echo "', '";
echo md5(md5($db->Record['password']));
echo "', '";
echo $db->Record['email'];
echo "', '";
echo qwe("123","value","5",$db->Record['id']);
echo "', '";
echo qwe("123","value","1",$db->Record['id']);
echo "', '";
echo qwe("123","value","3",$db->Record['id']);
echo "', '";
echo $db->Record['groupID'];
echo "');";
echo "<br/>";
				}
?>